SELECT SQL_CALC_FOUND_ROWS product.entity_id,Entity.entity_type,Entity.site_id,(published.entity_id IS NOT NULL) as published,Entity.archived FROM `rdcms_site_products` as `product` INNER JOIN rdcms_site_entities AS `Entity` ON (Entity.entity_id = product.entity_id) LEFT JOIN rdcms_site_content_entities as ContentEntity ON (ContentEntity.entity_id = Entity.entity_id) LEFT JOIN rdcms_published AS `published` ON (published.entity_id = product.entity_id) WHERE Entity.entity_type IN ('product', 'BOOK', 'SCHOOLBOOK', 'EBOOK', 'LIFESTYLE_ACCESSORY', 'COMPUTER', 'ELECTRONIC', 'MEDICAL_EQUIPMENT') AND Entity.site_id = '1' AND published.entity_id IS NOT NULL AND Entity.archived = '0' GROUP BY Entity.entity_id ORDER BY FIELD(product.entity_id, )